﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace SOA.DAL
{
    public class CompraManual
    {
        public void Salvar(SOA.MODEL.CompraManual compra)
        {            
            var sqlInsert = "INSERT INTO TB_COMPRA_MANUAL (QTDE_HOT_DOG_1, QTDE_HOT_DOG_2, QTDE_REFRI_1," +
            "QTDE_REFRI_2, DATA) " +
            "VALUES (";            
            sqlInsert += compra.QtdeHotDog1 + ",";
            sqlInsert += compra.QtdeHotDog2 + ",";
            sqlInsert += compra.QtdeRefri1 + ",";
            sqlInsert += compra.QtdeRefri2 + ",";            
            sqlInsert += "Now())";
            new Db().Execute(sqlInsert);            
        }
    }
}